package com.alibaba.ai.dao;

import com.alibaba.fastjson.JSONObject;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface ColumbiaMapper {
    //在售房源
    @Select("select f.f_picture_name,e.e_xarea_name,c.c_price,a.acreage from f_picture,e_xarea,f_acreage " +
            "where c.c_picture_id=f.id and c.c_xarea_id=e.id and c.c_acreage_id=a.id")
    List<JSONObject> getColumbia(String fPictureName, String eXareaName, String cPrice, Integer acreage);
}
